UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0ofCHZrcMPf7AlISuTkbEg1lH/p5tsDZm0orHTAMT+c='
WHERE
key_id = '9d5a19cb8586ce43a56a74f951baa75c89c3ff49afca50478503f7f082220821'
AND (
token = '0ofCHZrcMPf7AlISuTkbEg1lH/p5tsDZm0orHTAMT+c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)