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