UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qlZoHkLvbbNTD62vKJnhCpvWf39Bd6LxKOrnBhyG45I='
WHERE
key_id = 'f326bef6ba22a0467299a767a23b4c77871ee9d7d4cf16b280b06d6431dad554'
AND (
token = 'qlZoHkLvbbNTD62vKJnhCpvWf39Bd6LxKOrnBhyG45I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)