UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5abkN/WIM4JswpN9PLEpOlXdT72dfIXPt4Sgg6Yf0pk='
WHERE
key_id = 'b7a6f7620c627bef06dde63bf926f5fbaf91328adbe48da71a1e156889890957'
AND (
token = '5abkN/WIM4JswpN9PLEpOlXdT72dfIXPt4Sgg6Yf0pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)