UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jAKXi8nys2tDU6WiSrlW7PdQ69TXM5WJGPjgIFj6fZI='
WHERE
key_id = '7a87940833e9874d6e612dbdb559f5a6f8c7246381a0c81372d138bef21eae49'
AND (
token = 'jAKXi8nys2tDU6WiSrlW7PdQ69TXM5WJGPjgIFj6fZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)