UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DZM0zo9tsBvBBDc57MKpiU8BIcN95HYbThU9ge7FroU='
WHERE
key_id = '7f733fe1af344b9b77b259c65a65d82cd58631a412fac64d84d4fda6a3493598'
AND (
token = 'DZM0zo9tsBvBBDc57MKpiU8BIcN95HYbThU9ge7FroU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)