UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QpYfjfiKjHi10+Y3/pNIok0iM/frvTOFWHvZNcZb6wM='
WHERE
key_id = 'dfc36b5d405f4b0cc7e170597442fbadf0de47679337272d136511e0b7d1f35f'
AND (
token = 'QpYfjfiKjHi10+Y3/pNIok0iM/frvTOFWHvZNcZb6wM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)