UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lPmadlwXTjUPLgGAYrrC5HNbzKH5y901ZYnzIWleTE='
WHERE
key_id = '236fc9f8351448f79660a2bc71bfae6bf8fb045225d2bc2220b0a3b78da4edb4'
AND (
token = '4lPmadlwXTjUPLgGAYrrC5HNbzKH5y901ZYnzIWleTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)