UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8lPB1J8au1zS4BjlgAyaK/u/FxwYjr1p4AqtVfrj+n0='
WHERE
key_id = '528e27adb37ca0765a206fdca689d5ecb1fcdafd7e9ba6344012b656330811a0'
AND (
token = '8lPB1J8au1zS4BjlgAyaK/u/FxwYjr1p4AqtVfrj+n0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)