UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GKtNaTklkNr+YgHhUdhGzcThu6pScDPoaJB8viHo/Sc='
WHERE
key_id = 'c7f4e34653814935c48399d4b14f8d6ffcc07604aa84c7dab696227dc8b99037'
AND (
token = 'GKtNaTklkNr+YgHhUdhGzcThu6pScDPoaJB8viHo/Sc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)