UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZFt4BoduWvPsChOcZvANYiI8LEpb7fjtb83vXqqMWo='
WHERE
key_id = 'dd554e32219260a68b54c78608592538e7eb1dd586717ab88eccf25cf36d8c09'
AND (
token = 'SZFt4BoduWvPsChOcZvANYiI8LEpb7fjtb83vXqqMWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)