UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UnaP0FnGF2xiqxdoXryGc4H7OtDUXeX7Y6viKygBWVk='
WHERE
key_id = '159705c14327a085da40434eed27693d0fa962e39086645e7c6870e117ab1272'
AND (
token = 'UnaP0FnGF2xiqxdoXryGc4H7OtDUXeX7Y6viKygBWVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)