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