UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ddLyc1iV4qpsILpcOg9U4ZE7jx+wSSSly/H7IwOHerw='
WHERE
key_id = '8d0412bc8d617c1406c4d357c41beeccac6cb082523c66f214a04206b413b11c'
AND (
token = 'ddLyc1iV4qpsILpcOg9U4ZE7jx+wSSSly/H7IwOHerw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)