UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mKr7HSOVTugh/A8m0Baslr0YJ8pZy6V/KpxDjO/n1i8='
WHERE
key_id = 'd8aaab28d2dd11b77815f0142fc5b820747adab80fde3006c57a9e51f908885f'
AND (
token = 'mKr7HSOVTugh/A8m0Baslr0YJ8pZy6V/KpxDjO/n1i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)