UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUcmnz7wMGjNA3pG23fOOsgUd5q9nbQrHJbOGD/qdm8='
WHERE
key_id = '5ac40678b1154469c7aff19ec40f6bcc3dfc3e3f61da59a650f5e25a2fae3f4e'
AND (
token = 'CUcmnz7wMGjNA3pG23fOOsgUd5q9nbQrHJbOGD/qdm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)