UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T+N8sfGH5BisvrGcZKs7rPthV2JF9fX+CMo70h89qxg='
WHERE
key_id = 'd000bc980494b50801132fd8b700a9b0f825ffcf7d213f4d4c55f379e8a1495c'
AND (
token = 'T+N8sfGH5BisvrGcZKs7rPthV2JF9fX+CMo70h89qxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)