UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNgWzKVxNSZJld/8KAuE/FuySy3T0PDr516mMDJ8jHs='
WHERE
key_id = '21b50d8a8b29f5f481e3ca0a8168287e6b3a4795ce5e4bc19b8b982ef2828b2b'
AND (
token = 'zNgWzKVxNSZJld/8KAuE/FuySy3T0PDr516mMDJ8jHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)