UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kS4IPbwrshapOAxVCapGZ0ETCwI8vAL2Jc3Ch9drpyo='
WHERE
key_id = 'f7a5ab4206557ea4f8fe92874a9c2bfac1c03867636edd520c5b9e218f227836'
AND (
token = 'kS4IPbwrshapOAxVCapGZ0ETCwI8vAL2Jc3Ch9drpyo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)