UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c7Tz83Ii67yaT28Gz31kIsiXt4pHhehB7xIMGmOFA7A='
WHERE
key_id = '578f80851177a86278ee823a9f1d9f55e63a198d5617faafba2ca414bbd1135a'
AND (
token = 'c7Tz83Ii67yaT28Gz31kIsiXt4pHhehB7xIMGmOFA7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)