UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LYYh5BrFIkbUg7fHaoWxAbxL+E95b1GQWEowOzIZHKM='
WHERE
key_id = '167bc76a47a93a029bc73d646f7959d48942b375b356777020e224388751be87'
AND (
token = 'LYYh5BrFIkbUg7fHaoWxAbxL+E95b1GQWEowOzIZHKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)