UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ijm92WNjrVr0KK772hekmh0004l4PDtfrg79UQb6W4g='
WHERE
key_id = '399e8ea2b57dc1fd6f68ee40e5123ddbdbbe2e12b215bbe52e85600cdcdd8e33'
AND (
token = 'ijm92WNjrVr0KK772hekmh0004l4PDtfrg79UQb6W4g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)