UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n8NE/5Qk1hvnDV6Mv6noJXMncyWbWZQaH5B2gYOt1uY='
WHERE
key_id = 'b4c2d48e16ab9b18720fbebe70ea2b09dbed5f418661ac21120500c04805ee2d'
AND (
token = 'n8NE/5Qk1hvnDV6Mv6noJXMncyWbWZQaH5B2gYOt1uY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)