UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZzH7TkGix1W4KC7WeTLLgJaG6Xk6XKyuA9PYnBib1SM='
WHERE
key_id = '28679d45fb2e270318c30c53ecf68579b37c31787fab5a8b8f38ff3ec467f515'
AND (
token = 'ZzH7TkGix1W4KC7WeTLLgJaG6Xk6XKyuA9PYnBib1SM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)