UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1agsSWV7X/00sPslc8mpjpA+7FfUOgKkE2cPZwDdv8='
WHERE
key_id = 'ea4aef7d92177bb04a092f7734c6dfb3475e84e1b299f7ac5a0c236d6f4a460f'
AND (
token = 'x1agsSWV7X/00sPslc8mpjpA+7FfUOgKkE2cPZwDdv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)