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