UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WcJEpjWaBxp3ja0YGT+FT5q5m4izItpVsuHe80xU8lc='
WHERE
key_id = 'e4dd405a1c0b70489249f2a669fe1a28aff140693c3d13ea1acbf32e75a4a5df'
AND (
token = 'WcJEpjWaBxp3ja0YGT+FT5q5m4izItpVsuHe80xU8lc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)