UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZ5XErIe+7D8elpZD5AsPFUIVSTj6/8XunzoMtg/Ztc='
WHERE
key_id = 'dc7a668604349224693629be42b3f1e8020bafba8b5057af83c268374a9680f3'
AND (
token = 'lZ5XErIe+7D8elpZD5AsPFUIVSTj6/8XunzoMtg/Ztc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)