UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8ni5FE4F80rioPpzqVlS8fq5z2DiWlt8aG5fmOtFsIc='
WHERE
key_id = '57982a2a7dc31bc1cc5d7296eb4557a4fbf8430913992fbd8a39f8543800d1bf'
AND (
token = '8ni5FE4F80rioPpzqVlS8fq5z2DiWlt8aG5fmOtFsIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)