UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfbxDgRhqgkHJ5sov8NX6d3miWD3W5uQvo4OUA2dJw8='
WHERE
key_id = '848f87fb9d2fb56704affee94c226b4c823da9692f6f417a4f159fed4bc80983'
AND (
token = 'pfbxDgRhqgkHJ5sov8NX6d3miWD3W5uQvo4OUA2dJw8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)