UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kmZ7E16BIshbfJhMHaaOaBexJYsveEoOBi+LCtr20jI='
WHERE
key_id = 'a25f8bf7e2ce221efa40538bafbac9402b928a03572c362df6be6881ddb6b1c2'
AND (
token = 'kmZ7E16BIshbfJhMHaaOaBexJYsveEoOBi+LCtr20jI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)