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